Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	6500
Missing cells	5223
Missing cells (%)	4.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1015.8 KiB
Average record size in memory	160.0 B

Variable types

Text	3
Numeric	7
Categorical	3
Boolean	5
DateTime	2

Alerts

`Base Shipping Price` is highly overall correlated with `Cost` and 2 other fields	High correlation
`Cost` is highly overall correlated with `Base Shipping Price` and 2 other fields	High correlation
`Express Shipment` is highly overall correlated with `Transport`	High correlation
`Fragile` is highly overall correlated with `Material`	High correlation
`Height` is highly overall correlated with `Weight` and 1 other fields	High correlation
`International` is highly overall correlated with `Transport`	High correlation
`Material` is highly overall correlated with `Fragile`	High correlation
`Price Of Sculpture` is highly overall correlated with `Base Shipping Price` and 2 other fields	High correlation
`Transport` is highly overall correlated with `Express Shipment` and 1 other fields	High correlation
`Weight` is highly overall correlated with `Base Shipping Price` and 4 other fields	High correlation
`Width` is highly overall correlated with `Height` and 1 other fields	High correlation
`Artist Reputation` has 750 (11.5%) missing values	Missing
`Height` has 375 (5.8%) missing values	Missing
`Width` has 584 (9.0%) missing values	Missing
`Weight` has 587 (9.0%) missing values	Missing
`Material` has 764 (11.8%) missing values	Missing
`Transport` has 1392 (21.4%) missing values	Missing
`Remote Location` has 771 (11.9%) missing values	Missing
`Weight` is highly skewed (γ1 = 21.55617439)	Skewed
`Price Of Sculpture` is highly skewed (γ1 = 22.20682308)	Skewed
`Cost` is highly skewed (γ1 = 29.81745934)	Skewed
`Customer Id` has unique values	Unique
`Customer Location` has unique values	Unique

Reproduction

Analysis started	2024-11-09 15:21:00.919578
Analysis finished	2024-11-09 15:21:23.731150
Duration	22.81 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

Customer Id
Text

Unique

Distinct	6500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	50.9 KiB

Length

Max length	24
Median length	20
Mean length	19.561231
Min length	8

Characters and Unicode

Total characters	127148
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6500 ?
Unique (%)	100.0%

Sample

1st row	fffe3900350033003300
2nd row	fffe3800330031003900
3rd row	fffe3600370035003100
4th row	fffe350031003300
5th row	fffe3900320038003400

Value	Count	Frequency (%)
fffe3900350033003300	1	< 0.1%
fffe3900370032003400	1	< 0.1%
fffe350031003300	1	< 0.1%
fffe3900320038003400	1	< 0.1%
fffe3300390039003900	1	< 0.1%
fffe3800360033003700	1	< 0.1%
fffe3800300039003800	1	< 0.1%
fffe3800330032003900	1	< 0.1%
fffe3800310031003800	1	< 0.1%
fffe3100350034003800	1	< 0.1%
Other values (6490)	6490	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	52504	41.3%
3	27862	21.9%
f	19500	15.3%
e	6500	5.1%
6	2648	2.1%
2	2628	2.1%
1	2620	2.1%
9	2604	2.0%
8	2593	2.0%
4	2575	2.0%
Other values (2)	5114	4.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	127148	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	52504	41.3%
3	27862	21.9%
f	19500	15.3%
e	6500	5.1%
6	2648	2.1%
2	2628	2.1%
1	2620	2.1%
9	2604	2.0%
8	2593	2.0%
4	2575	2.0%
Other values (2)	5114	4.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	127148	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	52504	41.3%
3	27862	21.9%
f	19500	15.3%
e	6500	5.1%
6	2648	2.1%
2	2628	2.1%
1	2620	2.1%
9	2604	2.0%
8	2593	2.0%
4	2575	2.0%
Other values (2)	5114	4.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	127148	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	52504	41.3%
3	27862	21.9%
f	19500	15.3%
e	6500	5.1%
6	2648	2.1%
2	2628	2.1%
1	2620	2.1%
9	2604	2.0%
8	2593	2.0%
4	2575	2.0%
Other values (2)	5114	4.0%

Artist Name
Text

Distinct	6449
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Memory size	50.9 KiB

Length

Max length	22
Median length	20
Mean length	13.068
Min length	7

Characters and Unicode

Total characters	84942
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6403 ?
Unique (%)	98.5%

Sample

1st row	Billy Jenkins
2nd row	Jean Bryant
3rd row	Laura Miller
4th row	Robert Chaires
5th row	Rosalyn Krol

Value	Count	Frequency (%)
james	139	1.1%
robert	117	0.9%
john	102	0.8%
mary	100	0.8%
william	89	0.7%
thomas	87	0.7%
david	79	0.6%
michael	77	0.6%
smith	70	0.5%
johnson	61	0.5%
Other values (5061)	12079	92.9%

Most occurring characters

Value	Count	Frequency (%)
e	8389	9.9%
a	7771	9.1%
	6500	7.7%
r	6319	7.4%
n	5979	7.0%
i	5071	6.0%
o	4726	5.6%
l	4669	5.5%
s	3278	3.9%
t	3075	3.6%
Other values (43)	29165	34.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84942	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	8389	9.9%
a	7771	9.1%
	6500	7.7%
r	6319	7.4%
n	5979	7.0%
i	5071	6.0%
o	4726	5.6%
l	4669	5.5%
s	3278	3.9%
t	3075	3.6%
Other values (43)	29165	34.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84942	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	8389	9.9%
a	7771	9.1%
	6500	7.7%
r	6319	7.4%
n	5979	7.0%
i	5071	6.0%
o	4726	5.6%
l	4669	5.5%
s	3278	3.9%
t	3075	3.6%
Other values (43)	29165	34.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84942	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	8389	9.9%
a	7771	9.1%
	6500	7.7%
r	6319	7.4%
n	5979	7.0%
i	5071	6.0%
o	4726	5.6%
l	4669	5.5%
s	3278	3.9%
t	3075	3.6%
Other values (43)	29165	34.3%

Artist Reputation
Real number (ℝ)

Missing

Distinct	101
Distinct (%)	1.8%
Missing	750
Missing (%)	11.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.46185043

Minimum	0
Maximum	1
Zeros	22
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.06
Q1	0.24
median	0.45
Q3	0.68
95-th percentile	0.91
Maximum	1
Range	1
Interquartile range (IQR)	0.44

Descriptive statistics

Standard deviation	0.26578113
Coefficient of variation (CV)	0.57547013
Kurtosis	-1.0318797
Mean	0.46185043
Median Absolute Deviation (MAD)	0.22
Skewness	0.1413632
Sum	2655.64
Variance	0.070639609
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.36	90	1.4%
0.38	85	1.3%
0.22	79	1.2%
0.39	79	1.2%
0.17	79	1.2%
0.47	77	1.2%
0.37	77	1.2%
0.29	76	1.2%
0.6	75	1.2%
0.57	74	1.1%
Other values (91)	4959	76.3%
(Missing)	750	11.5%

Value	Count	Frequency (%)
0	22	0.3%
0.01	57	0.9%
0.02	60	0.9%
0.03	36	0.6%
0.04	45	0.7%
0.05	57	0.9%
0.06	54	0.8%
0.07	56	0.9%
0.08	64	1.0%
0.09	52	0.8%

Value	Count	Frequency (%)
1	12	0.2%
0.99	29	0.4%
0.98	25	0.4%
0.97	35	0.5%
0.96	32	0.5%
0.95	27	0.4%
0.94	41	0.6%
0.93	35	0.5%
0.92	36	0.6%
0.91	31	0.5%

Height
Real number (ℝ)

High correlation Missing

Distinct	65
Distinct (%)	1.1%
Missing	375
Missing (%)	5.8%
Infinite	0
Infinite (%)	0.0%
Mean	21.766204

Minimum	3
Maximum	73
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	3
5-th percentile	5
Q1	12
median	20
Q3	30
95-th percentile	44
Maximum	73
Range	70
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	11.968192
Coefficient of variation (CV)	0.54985206
Kurtosis	-0.0052948465
Mean	21.766204
Median Absolute Deviation (MAD)	8
Skewness	0.59404059
Sum	133318
Variance	143.23762
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	211	3.2%
19	209	3.2%
15	204	3.1%
16	192	3.0%
13	191	2.9%
18	191	2.9%
26	183	2.8%
9	180	2.8%
22	180	2.8%
20	180	2.8%
Other values (55)	4204	64.7%
(Missing)	375	5.8%

Value	Count	Frequency (%)
3	148	2.3%
4	129	2.0%
5	135	2.1%
6	129	2.0%
7	141	2.2%
8	167	2.6%
9	180	2.8%
10	170	2.6%
11	148	2.3%
12	211	3.2%

Value	Count	Frequency (%)
73	1	< 0.1%
68	2	< 0.1%
66	2	< 0.1%
65	1	< 0.1%
64	5	0.1%
62	2	< 0.1%
61	4	0.1%
60	3	< 0.1%
59	3	< 0.1%
58	7	0.1%

Width
Real number (ℝ)

High correlation Missing

Distinct	40
Distinct (%)	0.7%
Missing	584
Missing (%)	9.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.6176471

Minimum	2
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	2
5-th percentile	4
Q1	6
median	8
Q3	12
95-th percentile	21
Maximum	50
Range	48
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	5.4170002
Coefficient of variation (CV)	0.5632355
Kurtosis	3.3617162
Mean	9.6176471
Median Absolute Deviation (MAD)	3
Skewness	1.5467021
Sum	56898
Variance	29.343891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
8	741	11.4%
6	722	11.1%
7	698	10.7%
4	473	7.3%
5	435	6.7%
9	347	5.3%
10	326	5.0%
11	311	4.8%
12	261	4.0%
13	207	3.2%
Other values (30)	1395	21.5%
(Missing)	584	9.0%

Value	Count	Frequency (%)
2	76	1.2%
3	164	2.5%
4	473	7.3%
5	435	6.7%
6	722	11.1%
7	698	10.7%
8	741	11.4%
9	347	5.3%
10	326	5.0%
11	311	4.8%

Value	Count	Frequency (%)
50	1	< 0.1%
45	1	< 0.1%
44	1	< 0.1%
39	1	< 0.1%
37	3	< 0.1%
36	3	< 0.1%
35	2	< 0.1%
34	3	< 0.1%
33	6	0.1%
32	5	0.1%

Weight
Real number (ℝ)

High correlation Missing Skewed

Distinct	4410
Distinct (%)	74.6%
Missing	587
Missing (%)	9.0%
Infinite	0
Infinite (%)	0.0%
Mean	400694.82

Minimum	3
Maximum	1.1792787 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	3
5-th percentile	63.6
Q1	503
median	3102
Q3	36456
95-th percentile	1430595.4
Maximum	1.1792787 × 10⁸
Range	1.1792787 × 10⁸
Interquartile range (IQR)	35953

Descriptive statistics

Standard deviation	2678081.2
Coefficient of variation (CV)	6.6835933
Kurtosis	731.84356
Mean	400694.82
Median Absolute Deviation (MAD)	2992
Skewness	21.556174
Sum	2.3693085 × 10⁹
Variance	7.1721191 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
58	12	0.2%
237	10	0.2%
84	10	0.2%
41	10	0.2%
33	9	0.1%
90	9	0.1%
220	9	0.1%
39	9	0.1%
112	9	0.1%
11	8	0.1%
Other values (4400)	5818	89.5%
(Missing)	587	9.0%

Value	Count	Frequency (%)
3	1	< 0.1%
4	3	< 0.1%
5	3	< 0.1%
6	3	< 0.1%
8	3	< 0.1%
10	6	0.1%
11	8	0.1%
12	3	< 0.1%
13	8	0.1%
14	5	0.1%

Value	Count	Frequency (%)
117927869	1	< 0.1%
53118478	1	< 0.1%
49145353	1	< 0.1%
47717848	1	< 0.1%
47544217	1	< 0.1%
44587296	1	< 0.1%
29282087	1	< 0.1%
27317777	1	< 0.1%
26793635	1	< 0.1%
25254560	1	< 0.1%

Material
Categorical

High correlation Missing

Distinct	7
Distinct (%)	0.1%
Missing	764
Missing (%)	11.8%
Memory size	50.9 KiB

Brass	847
Aluminium	845
Bronze	821
Marble	819
Clay	816
Other values (2)	1588

Length

Max length	9
Median length	6
Mean length	5.5906555
Min length	4

Characters and Unicode

Total characters	32068
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Brass
2nd row	Brass
3rd row	Clay
4th row	Aluminium
5th row	Aluminium

Common Values

Value	Count	Frequency (%)
Brass	847	13.0%
Aluminium	845	13.0%
Bronze	821	12.6%
Marble	819	12.6%
Clay	816	12.6%
Wood	816	12.6%
Stone	772	11.9%
(Missing)	764	11.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
brass	847	14.8%
aluminium	845	14.7%
bronze	821	14.3%
marble	819	14.3%
clay	816	14.2%
wood	816	14.2%
stone	772	13.5%

Most occurring characters

Value	Count	Frequency (%)
o	3225	10.1%
r	2487	7.8%
a	2482	7.7%
l	2480	7.7%
n	2438	7.6%
e	2412	7.5%
s	1694	5.3%
u	1690	5.3%
m	1690	5.3%
i	1690	5.3%
Other values (11)	9780	30.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	32068	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	3225	10.1%
r	2487	7.8%
a	2482	7.7%
l	2480	7.7%
n	2438	7.6%
e	2412	7.5%
s	1694	5.3%
u	1690	5.3%
m	1690	5.3%
i	1690	5.3%
Other values (11)	9780	30.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	32068	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	3225	10.1%
r	2487	7.8%
a	2482	7.7%
l	2480	7.7%
n	2438	7.6%
e	2412	7.5%
s	1694	5.3%
u	1690	5.3%
m	1690	5.3%
i	1690	5.3%
Other values (11)	9780	30.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	32068	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	3225	10.1%
r	2487	7.8%
a	2482	7.7%
l	2480	7.7%
n	2438	7.6%
e	2412	7.5%
s	1694	5.3%
u	1690	5.3%
m	1690	5.3%
i	1690	5.3%
Other values (11)	9780	30.5%

Price Of Sculpture
Real number (ℝ)

High correlation Skewed

Distinct	3424
Distinct (%)	52.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1192.4201

Minimum	3
Maximum	382385.67
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	3
5-th percentile	3.44
Q1	5.23
median	8.025
Q3	89.47
95-th percentile	3631.7655
Maximum	382385.67
Range	382382.67
Interquartile range (IQR)	84.24

Descriptive statistics

Standard deviation	8819.6168
Coefficient of variation (CV)	7.3964007
Kurtosis	727.30112
Mean	1192.4201
Median Absolute Deviation (MAD)	4.515
Skewness	22.206823
Sum	7750730.6
Variance	77785640
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.27	19	0.3%
3.82	16	0.2%
5.1	16	0.2%
6.58	16	0.2%
5.54	16	0.2%
5.31	15	0.2%
4.89	14	0.2%
6.1	14	0.2%
3.06	14	0.2%
6.61	14	0.2%
Other values (3414)	6346	97.6%

Value	Count	Frequency (%)
3	6	0.1%
3.01	11	0.2%
3.02	12	0.2%
3.03	6	0.1%
3.04	9	0.1%
3.05	5	0.1%
3.06	14	0.2%
3.07	6	0.1%
3.08	7	0.1%
3.09	4	0.1%

Value	Count	Frequency (%)
382385.67	1	< 0.1%
231660.46	1	< 0.1%
230578.77	1	< 0.1%
162583.13	1	< 0.1%
135878.04	1	< 0.1%
114355.43	1	< 0.1%
105746.47	1	< 0.1%
102245.98	1	< 0.1%
98670.21	1	< 0.1%
88827.64	1	< 0.1%

Base Shipping Price
Real number (ℝ)

High correlation

Distinct	3732
Distinct (%)	57.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.407174

Minimum	10
Maximum	99.98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	10
5-th percentile	11.33
Q1	16.7
median	23.505
Q3	57.905
95-th percentile	91.5805
Maximum	99.98
Range	89.98
Interquartile range (IQR)	41.205

Descriptive statistics

Standard deviation	26.873519
Coefficient of variation (CV)	0.71840548
Kurtosis	-0.57931572
Mean	37.407174
Median Absolute Deviation (MAD)	10.475
Skewness	0.91810238
Sum	243146.63
Variance	722.186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.5	10	0.2%
10.68	9	0.1%
19.46	8	0.1%
12.89	7	0.1%
22.96	7	0.1%
17.95	7	0.1%
20.78	7	0.1%
24.87	7	0.1%
18.32	7	0.1%
14.65	7	0.1%
Other values (3722)	6424	98.8%

Value	Count	Frequency (%)
10	3	< 0.1%
10.01	2	< 0.1%
10.03	3	< 0.1%
10.04	2	< 0.1%
10.05	1	< 0.1%
10.06	3	< 0.1%
10.07	3	< 0.1%
10.08	2	< 0.1%
10.09	2	< 0.1%
10.1	2	< 0.1%

Value	Count	Frequency (%)
99.98	1	< 0.1%
99.95	1	< 0.1%
99.91	1	< 0.1%
99.81	1	< 0.1%
99.8	1	< 0.1%
99.76	1	< 0.1%
99.72	1	< 0.1%
99.71	2	< 0.1%
99.64	1	< 0.1%
99.61	1	< 0.1%

International
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.5 KiB

False	4294
True	2206

Value	Count	Frequency (%)
False	4294	66.1%
True	2206	33.9%

Express Shipment
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.5 KiB

False	4365
True	2135

Value	Count	Frequency (%)
False	4365	67.2%
True	2135	32.8%

Installation Included
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.5 KiB

False	3916
True	2584

Value	Count	Frequency (%)
False	3916	60.2%
True	2584	39.8%

Transport
Categorical

High correlation Missing

Distinct	3
Distinct (%)	0.1%
Missing	1392
Missing (%)	21.4%
Memory size	50.9 KiB

Roadways	2064
Airways	1817
Waterways	1227

Length

Max length	9
Median length	8
Mean length	7.8844949
Min length	7

Characters and Unicode

Total characters	40274
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Airways
2nd row	Roadways
3rd row	Roadways
4th row	Airways
5th row	Roadways

Common Values

Value	Count	Frequency (%)
Roadways	2064	31.8%
Airways	1817	28.0%
Waterways	1227	18.9%
(Missing)	1392	21.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
roadways	2064	40.4%
airways	1817	35.6%
waterways	1227	24.0%

Most occurring characters

Value	Count	Frequency (%)
a	8399	20.9%
w	5108	12.7%
y	5108	12.7%
s	5108	12.7%
r	3044	7.6%
R	2064	5.1%
o	2064	5.1%
d	2064	5.1%
A	1817	4.5%
i	1817	4.5%
Other values (3)	3681	9.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	40274	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	8399	20.9%
w	5108	12.7%
y	5108	12.7%
s	5108	12.7%
r	3044	7.6%
R	2064	5.1%
o	2064	5.1%
d	2064	5.1%
A	1817	4.5%
i	1817	4.5%
Other values (3)	3681	9.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	40274	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	8399	20.9%
w	5108	12.7%
y	5108	12.7%
s	5108	12.7%
r	3044	7.6%
R	2064	5.1%
o	2064	5.1%
d	2064	5.1%
A	1817	4.5%
i	1817	4.5%
Other values (3)	3681	9.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	40274	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	8399	20.9%
w	5108	12.7%
y	5108	12.7%
s	5108	12.7%
r	3044	7.6%
R	2064	5.1%
o	2064	5.1%
d	2064	5.1%
A	1817	4.5%
i	1817	4.5%
Other values (3)	3681	9.1%

Fragile
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.5 KiB

False	5461
True	1039

Value	Count	Frequency (%)
False	5461	84.0%
True	1039	16.0%

Customer Information
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	50.9 KiB

Working Class	4803
Wealthy	1697

Length

Max length	13
Median length	13
Mean length	11.433538
Min length	7

Characters and Unicode

Total characters	74318
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Working Class
2nd row	Working Class
3rd row	Working Class
4th row	Wealthy
5th row	Working Class

Common Values

Value	Count	Frequency (%)
Working Class	4803	73.9%
Wealthy	1697	26.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
working	4803	42.5%
class	4803	42.5%
wealthy	1697	15.0%

Most occurring characters

Value	Count	Frequency (%)
s	9606	12.9%
W	6500	8.7%
l	6500	8.7%
a	6500	8.7%
o	4803	6.5%
r	4803	6.5%
k	4803	6.5%
i	4803	6.5%
n	4803	6.5%
g	4803	6.5%
Other values (6)	16394	22.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	74318	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	9606	12.9%
W	6500	8.7%
l	6500	8.7%
a	6500	8.7%
o	4803	6.5%
r	4803	6.5%
k	4803	6.5%
i	4803	6.5%
n	4803	6.5%
g	4803	6.5%
Other values (6)	16394	22.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	74318	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	9606	12.9%
W	6500	8.7%
l	6500	8.7%
a	6500	8.7%
o	4803	6.5%
r	4803	6.5%
k	4803	6.5%
i	4803	6.5%
n	4803	6.5%
g	4803	6.5%
Other values (6)	16394	22.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	74318	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	9606	12.9%
W	6500	8.7%
l	6500	8.7%
a	6500	8.7%
o	4803	6.5%
r	4803	6.5%
k	4803	6.5%
i	4803	6.5%
n	4803	6.5%
g	4803	6.5%
Other values (6)	16394	22.1%

Remote Location
Boolean

Missing

Distinct	2
Distinct (%)	< 0.1%
Missing	771
Missing (%)	11.9%
Memory size	12.8 KiB

False	4594
True	1135
(Missing)	771

Value	Count	Frequency (%)
False	4594	70.7%
True	1135	17.5%
(Missing)	771	11.9%

Scheduled Date
Date

Distinct	1660
Distinct (%)	25.5%
Missing	0
Missing (%)	0.0%
Memory size	50.9 KiB

Minimum	2015-01-01 00:00:00
Maximum	2019-08-27 00:00:00

Histogram with fixed size bins (bins=50)

Delivery Date
Date

Distinct	1664
Distinct (%)	25.6%
Missing	0
Missing (%)	0.0%
Memory size	50.9 KiB

Minimum	2015-01-01 00:00:00
Maximum	2019-08-29 00:00:00

Histogram with fixed size bins (bins=50)

Customer Location
Text

Unique

Distinct	6500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	50.9 KiB

Length

Max length	34
Median length	31
Mean length	20.864615
Min length	12

Characters and Unicode

Total characters	135620
Distinct characters	64
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6500 ?
Unique (%)	100.0%

Sample

1st row	New Michelle, OH 50777
2nd row	New Michaelport, WY 12072
3rd row	Bowmanshire, WA 19241
4th row	East Robyn, KY 86375
5th row	Aprilside, PA 52793

Value	Count	Frequency (%)
new	417	1.9%
port	413	1.8%
south	410	1.8%
east	406	1.8%
lake	400	1.8%
north	396	1.8%
west	384	1.7%
ap	250	1.1%
aa	245	1.1%
dpo	244	1.1%
Other values (10158)	18761	84.0%

Most occurring characters

Value	Count	Frequency (%)
	15826	11.7%
e	6574	4.8%
,	5783	4.3%
t	5455	4.0%
a	5437	4.0%
r	5411	4.0%
o	4752	3.5%
h	3814	2.8%
n	3688	2.7%
i	3420	2.5%
Other values (54)	75460	55.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	135620	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	15826	11.7%
e	6574	4.8%
,	5783	4.3%
t	5455	4.0%
a	5437	4.0%
r	5411	4.0%
o	4752	3.5%
h	3814	2.8%
n	3688	2.7%
i	3420	2.5%
Other values (54)	75460	55.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	135620	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	15826	11.7%
e	6574	4.8%
,	5783	4.3%
t	5455	4.0%
a	5437	4.0%
r	5411	4.0%
o	4752	3.5%
h	3814	2.8%
n	3688	2.7%
i	3420	2.5%
Other values (54)	75460	55.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	135620	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	15826	11.7%
e	6574	4.8%
,	5783	4.3%
t	5455	4.0%
a	5437	4.0%
r	5411	4.0%
o	4752	3.5%
h	3814	2.8%
n	3688	2.7%
i	3420	2.5%
Other values (54)	75460	55.6%

Cost
Real number (ℝ)

High correlation Skewed

Distinct	6356
Distinct (%)	97.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17139.196

Minimum	-880172.65
Maximum	11143428
Zeros	0
Zeros (%)	0.0%
Negative	659
Negative (%)	10.1%
Memory size	50.9 KiB

Quantile statistics

Minimum	-880172.65
5-th percentile	-432.166
Q1	188.44
median	382.065
Q3	1156.115
95-th percentile	18543.878
Maximum	11143428
Range	12023601
Interquartile range (IQR)	967.675

Descriptive statistics

Standard deviation	240657.87
Coefficient of variation (CV)	14.041375
Kurtosis	1124.7715
Mean	17139.196
Median Absolute Deviation (MAD)	249.26
Skewness	29.817459
Sum	1.1140477 × 10⁸
Variance	5.791621 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
144.45	4	0.1%
479.27	3	< 0.1%
193.79	3	< 0.1%
269.99	3	< 0.1%
283.6	3	< 0.1%
191.55	3	< 0.1%
176.82	2	< 0.1%
349.03	2	< 0.1%
282.01	2	< 0.1%
915.1	2	< 0.1%
Other values (6346)	6473	99.6%

Value	Count	Frequency (%)
-880172.65	1	< 0.1%
-588183.2	1	< 0.1%
-360814.49	1	< 0.1%
-322018.37	1	< 0.1%
-252965.99	1	< 0.1%
-244885.22	1	< 0.1%
-236681.06	1	< 0.1%
-162573.71	1	< 0.1%
-144567.29	1	< 0.1%
-133988.47	1	< 0.1%

Value	Count	Frequency (%)
11143428.25	1	< 0.1%
9177540.38	1	< 0.1%
4992890.84	1	< 0.1%
4976100.89	1	< 0.1%
4020731.9	1	< 0.1%
3792938.06	1	< 0.1%
3362175.6	1	< 0.1%
3324867.29	1	< 0.1%
3117106.66	1	< 0.1%
2829193.76	1	< 0.1%

	Artist Reputation	Base Shipping Price	Cost	Customer Information	Express Shipment	Fragile	Height	Installation Included	International	Material	Price Of Sculpture	Remote Location	Transport	Weight	Width
Artist Reputation	1.000	-0.003	0.352	0.016	0.000	0.019	-0.000	0.008	0.027	0.031	0.091	0.000	0.039	0.009	-0.011
Base Shipping Price	-0.003	1.000	0.594	0.015	0.020	0.124	0.374	0.000	0.000	0.267	0.703	0.000	0.000	0.740	0.370
Cost	0.352	0.594	1.000	0.000	0.051	0.000	0.396	0.033	0.011	0.066	0.656	0.000	0.000	0.661	0.387
Customer Information	0.016	0.015	0.000	1.000	0.368	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.207	0.000	0.000
Express Shipment	0.000	0.020	0.051	0.368	1.000	0.000	0.020	0.000	0.010	0.042	0.018	0.000	0.552	0.005	0.000
Fragile	0.019	0.124	0.000	0.000	0.000	1.000	0.131	0.000	0.000	0.937	0.014	0.000	0.000	0.000	0.077
Height	-0.000	0.374	0.396	0.000	0.020	0.131	1.000	0.028	0.017	0.007	0.436	0.000	0.013	0.558	0.826
Installation Included	0.008	0.000	0.033	0.000	0.000	0.000	0.028	1.000	0.013	0.018	0.015	0.000	0.018	0.007	0.000
International	0.027	0.000	0.011	0.000	0.010	0.000	0.017	0.013	1.000	0.000	0.016	0.000	0.528	0.000	0.000
Material	0.031	0.267	0.066	0.000	0.042	0.937	0.007	0.018	0.000	1.000	0.059	0.000	0.028	0.069	0.007
Price Of Sculpture	0.091	0.703	0.656	0.000	0.018	0.014	0.436	0.015	0.016	0.059	1.000	0.005	0.000	0.872	0.432
Remote Location	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.005	1.000	0.000	0.000	0.031
Transport	0.039	0.000	0.000	0.207	0.552	0.000	0.013	0.018	0.528	0.028	0.000	0.000	1.000	0.004	0.000
Weight	0.009	0.740	0.661	0.000	0.005	0.000	0.558	0.007	0.000	0.069	0.872	0.000	0.004	1.000	0.559
Width	-0.011	0.370	0.387	0.000	0.000	0.077	0.826	0.000	0.000	0.007	0.432	0.031	0.000	0.559	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Customer Id	Artist Name	Artist Reputation	Height	Width	Weight	Material	Price Of Sculpture	Base Shipping Price	International	Express Shipment	Installation Included	Transport	Fragile	Customer Information	Remote Location	Scheduled Date	Delivery Date	Customer Location	Cost
0	fffe3900350033003300	Billy Jenkins	0.26	17.0	6.0	4128.0	Brass	13.91	16.27	Yes	Yes	No	Airways	No	Working Class	No	06/07/15	06/03/15	New Michelle, OH 50777	-283.29
1	fffe3800330031003900	Jean Bryant	0.28	3.0	3.0	61.0	Brass	6.83	15.00	No	No	No	Roadways	No	Working Class	No	03/06/17	03/05/17	New Michaelport, WY 12072	-159.96
2	fffe3600370035003100	Laura Miller	0.07	8.0	5.0	237.0	Clay	4.96	21.18	No	No	No	Roadways	Yes	Working Class	Yes	03/09/15	03/08/15	Bowmanshire, WA 19241	-154.29
3	fffe350031003300	Robert Chaires	0.12	9.0	NaN	NaN	Aluminium	5.81	16.31	No	No	No	NaN	No	Wealthy	Yes	05/24/15	05/20/15	East Robyn, KY 86375	-161.16
4	fffe3900320038003400	Rosalyn Krol	0.15	17.0	6.0	324.0	Aluminium	3.18	11.94	Yes	Yes	Yes	Airways	No	Working Class	No	12/18/16	12/14/16	Aprilside, PA 52793	-159.23
5	fffe3300390039003900	Tracy Francis	0.99	46.0	19.0	1178.0	Wood	6.16	16.88	No	Yes	No	NaN	No	Wealthy	No	08/28/15	08/26/15	Maddenberg, AL 43096	-1922.78
6	fffe3800360033003700	David Hawes	0.64	17.0	9.0	7264.0	Brass	8.26	90.67	No	Yes	No	Roadways	No	Working Class	No	06/05/16	06/02/16	South Matthew, WV 76033	-1536.66
7	fffe3800300039003800	David Osher	0.74	23.0	10.0	3287.0	Clay	12.81	13.25	Yes	No	No	Waterways	Yes	Wealthy	No	06/04/19	05/31/19	Davidmouth, CA 37824	-422.42
8	fffe3800330032003900	Arnold Reel	0.00	6.0	4.0	108.0	Clay	3.98	19.76	Yes	No	No	Waterways	Yes	Working Class	Yes	08/27/18	08/23/18	Lisaville, ND 43925	-160.10
9	fffe3800310031003800	James Comfort	0.12	23.0	9.0	195226.0	Marble	245.63	49.25	No	No	No	Roadways	No	Working Class	No	07/14/16	07/10/16	Jacobland, WV 85997	-834.27

	Customer Id	Artist Name	Artist Reputation	Height	Width	Weight	Material	Price Of Sculpture	Base Shipping Price	International	Express Shipment	Installation Included	Transport	Fragile	Customer Information	Remote Location	Scheduled Date	Delivery Date	Customer Location	Cost
6490	fffe3700330035003000	Charles Jones	0.52	15.0	8.0	97958.0	Stone	245.85	28.59	No	No	No	Roadways	No	Working Class	No	02/28/15	02/26/15	Riceburgh, DC 87672	1075.95
6491	fffe3800300035003500	Berry Simmons	0.67	13.0	8.0	475.0	Aluminium	3.65	12.93	Yes	No	Yes	Roadways	No	Working Class	No	10/28/18	10/27/18	Jessicachester, MA 84581	294.62
6492	fffe3800350039003100	Tiffanie Moreno	0.80	17.0	12.0	424586.0	Stone	1648.14	61.13	No	No	Yes	Roadways	No	Working Class	No	09/12/15	09/14/15	Murphystad, MO 17941	5177.64
6493	fffe350037003800	William Curry	NaN	13.0	8.0	154.0	Wood	5.33	13.00	No	Yes	No	Airways	No	Wealthy	No	03/16/17	03/16/17	Jerryland, CO 24340	174.57
6494	fffe3300370030003500	Karen Bayles	0.45	NaN	28.0	10851.0	Aluminium	30.83	67.70	No	No	Yes	Roadways	No	Working Class	No	04/19/16	04/21/16	Singletonstad, MD 79303	1076.85
6495	fffe3800370037003300	Jeffrey Freudenthal	0.37	37.0	10.0	16551.0	Brass	28.28	38.46	Yes	Yes	No	Airways	No	Wealthy	Yes	03/28/18	03/25/18	New Robert, VT 85335	872.43
6496	fffe310036003400	Larry Edwards	0.67	15.0	NaN	18981.0	NaN	67.18	27.72	No	No	No	Roadways	No	Working Class	No	08/29/15	08/27/15	New Joshua, VA 35766	1347.02
6497	fffe3600300031003300	Denise Worth	0.68	19.0	8.0	587.0	Clay	6.92	10.38	Yes	No	No	NaN	Yes	Wealthy	No	04/10/19	04/09/19	Lake Kelly, MA 80823	354.55
6498	fffe3600350035003900	Daniel Drew	0.02	33.0	9.0	1269377.0	Stone	2929.13	69.76	No	Yes	No	Roadways	No	Working Class	Yes	03/10/19	03/12/19	Hintonberg, UT 35006	5037.50
6499	fffe3700310031003600	Vernon Carroll	0.18	30.0	13.0	34729.0	Brass	46.63	78.25	No	Yes	No	Airways	No	Working Class	No	12/03/16	12/05/16	New Christopher, AK 87406	722.47

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample